haymen.roth.3

i am picking list of names from database, according to scenario each name exists many times in database, That's ok. Now i have filled a DROPDOWNLIST with those names but in drop down list each name appears several times but i want to display each name 1 time in DROPDOWN. …

i am told t use old traditional way of SQL in MVC so created login register page but now problem is that i can't return data to VIEW from dataset. Model public ConnectionStatus Login_db(String email, String pwd, String conStr) { String hashedpwd_login = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "SHA1"); using (SqlConnection sqlCon = new …

i am receiving Emplid in this action, public ActionResult showDDL(int? EmplID = null) { ViewBag.EmplID = EmplID; if (EmplID == null) { IEnumerable<GetAtdRecord_SpResult> EmployeeAtd_2 = DataContext.GetAtdRecord_Sp(0).ToList(); return View(EmployeeAtd_2); } else if (EmplID != null) { IEnumerable<GetAtdRecord_SpResult> EmployeeAtd_2 = DataContext.GetAtdRecord_Sp(EmplID).ToList(); return View(EmployeeAtd_2); } return View(); } View: @{ var grid = …

this query was working fine but when added OverTime part then it started throwing error: Msg 8117, Level 16, State 1, Line 52 Operand data type varchar is invalid for sum operator. with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t4.ShiftId …

This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 …

i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date …

In if else structure when null arguments are passed to two string variables then it always hit the condition when i have set Var1 != "" && Var2 != "" why ? since nulls are passed to both then why it hits this condition ? code: public ActionResult ShowCalTextBox(String DateFrom, …

i am bit confused by the nature and working of query , I tried to access database which contains each name more than once having same EMPid so when i accessed it in my DROP DOWN LIST then same repetition was in there too so i tried to remove repetition …

i have wrote query to calculate TOTAL WORK TIME and Overtime of an employee based on Intime and outTime but can't figure out to put another column 'IsAbsent'. e.g. if person doesn't come on any specific date than his INtime and TimeOut would be empty then if both are empty …

Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. …

Background: My store procedure 'GetAtdRecord_Sp' to optionally accept parameter 'EmplID' otherwise default value is null. It works in SQl server management studio even if i provide no value as i wanted to do. exec GetAtdRecord_Sp // This works exec GetAtdRecord_Sp 23 // This works too with value. Problem: But when …

i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …