static void Main(string[] args) { try { // variable declaration BCStudent objStudent = new BCStudent(); int studentId = 0; int UserRoleId = 5; int stagePlanId = 0; double stageDistance = 0; double distCovered = 0; Int32 UserId = 0; DataTable studInfo = null; string UserName = string.Empty; Int32 schoolId = 0; Int32 classId = 0; Int32 cityId = 0; // end variable declaration // Get student info StringBuilder sqlString = new StringBuilder(); sqlString.Append("select * from LoginDtls where LoginName='"); sqlString.Append(args[0]); sqlString.Append("' and cast(Password as varbinary(20))=cast('"); sqlString.Append(args[1]); sqlString.Append("' as varbinary(50)) and IsActive=1"); var login = DataAccessLayer.ReturnDataTable(sqlString.ToString()); if (login != null) { UserRoleId = Convert.ToInt32(login.Rows[0]["RoleId"]); UserId = Convert.ToInt32(login.Rows[0]["LoginId"]); UserName = Convert.ToString(login.Rows[0]["LoginName"]); if (UserRoleId == 5) { sqlString = new StringBuilder(); sqlString.Append("Select * FROM StudentMaster Where LoginId = "); sqlString.Append(UserId); var student = DataAccessLayer.ReturnDataTable(sqlString.ToString()); if (student != null && student.Rows.Count > 0) { schoolId = Convert.ToInt32(student.Rows[0]["SchoolId"]); classId = Convert.ToInt32(student.Rows[0]["ClassId"]); cityId = Convert.ToInt32(student.Rows[0]["CityId"]); studentId = Convert.ToInt32(student.Rows[0]["StudentId"]); } } studInfo = objStudent.GetMyProfileInfo(studentId); schoolId = Convert.ToInt32(studInfo.Rows[0]["SchoolId"]); classId = Convert.ToInt32(studInfo.Rows[0]["ClassId"]); DataSet _dtStage = objStudent.GetCurrentStageInfo((studentId > 0 ? studentId : UserId), UserRoleId, classId); if (_dtStage.Tables[0].Rows.Count > 0) { stagePlanId = Convert.ToInt32(_dtStage.Tables[0].Rows[0]["StagePlanId"]); stageDistance = Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance"]); distCovered = double.Parse(_dtStage.Tables[0].Rows[0]["Distance_Covered"].ToString(), System.Globalization.CultureInfo.InvariantCulture); //Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance_Covered"]); } int res = objStudent.StudentsDeleteLastUpload( UserRoleId, UserId, 0, studentId, stagePlanId, stageDistance, distCovered, classId, 1); } else { Console.WriteLine("Incorrect Username or Password"); } } catch (Exception ex) { Console.WriteLine("No last file found or internal server error occured, following are details : \n\n" + ex.Message); } }