} //end function public StudentGuardianRecord StudentGuardianRecordSelectByID(int intGuardianID) { try { string sp_name = "StudentGuardianRecordSelectByID"; comStudentGuardianRecord.Parameters.AddWithValue("GuardianID", intGuardianID); ConnectAndExecute(sp_name); //no parameter will send to stored procedure if (dsStudentGuardianRecord.Tables[0].Rows.Count == 1) { DataRow drStudentGuardianRecord = dsStudentGuardianRecord.Tables[0].Rows[0]; StudentGuardianRecord objStudentGuardianRecord = new StudentGuardianRecord(); objStudentGuardianRecord.GuardianID = Convert.ToInt64(drStudentGuardianRecord["GuardianID"]); objStudentGuardianRecord.StudentID = Convert.ToInt64(drStudentGuardianRecord["StudentID"]); objStudentGuardianRecord.GuardianName = Convert.ToString(drStudentGuardianRecord["GuardianName"]); objStudentGuardianRecord.GuardianCNIC = Convert.ToString(drStudentGuardianRecord["GuardianCNIC"]); objStudentGuardianRecord.GuadianEmail = Convert.ToString(drStudentGuardianRecord["GuadianEmail"]); objStudentGuardianRecord.GuardianContact = Convert.ToString(drStudentGuardianRecord["GuardianContact"]); objStudentGuardianRecord.GuardianPic = Convert.ToString(drStudentGuardianRecord["GuardianPic"]); objStudentGuardianRecord.GuardianAddress = Convert.ToString(drStudentGuardianRecord["GuardianAddress"]); objStudentGuardianRecord.AddedByID = Convert.ToInt64(drStudentGuardianRecord["AddedByID"]); objStudentGuardianRecord.AddedDateTime = Convert.ToDateTime(drStudentGuardianRecord["AddedDateTime"]); objStudentGuardianRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentGuardianRecord["LastUpdateDateTime"]); objStudentGuardianRecord.LastUpdateByID = Convert.ToInt64(drStudentGuardianRecord["LastUpdateByID"]); objStudentGuardianRecord.Remarks = Convert.ToString(drStudentGuardianRecord["Remarks"]); return(objStudentGuardianRecord); } return(null); } catch (Exception ex) { SetError(ex.Message); return(null); } //end try } //end function
private void StudentGurdianInsertUpdate(Int64 student_Id = 0) { Image guardian_pic = picGuardin.Image; guardian_pic.Save("guardian//image//" + txtGuardianCNIC.Text + ".jpg"); StudentGuardianRecord studentGuardianRecord = new StudentGuardianRecord(); studentGuardianRecord.GuardianID = 0; studentGuardianRecord.StudentID = student_Id; studentGuardianRecord.GuardianName = txtGuardianName.Text; studentGuardianRecord.GuardianCNIC = txtGuardianCNIC.Text; studentGuardianRecord.GuadianEmail = txtGuardianEmail.Text; studentGuardianRecord.GuardianContact = txtGuardianPhoneNo.Text; studentGuardianRecord.GuardianPic = "guardiang//image//" + txtGuardianCNIC.Text + ".jpg"; studentGuardianRecord.GuardianAddress = txtGuardianAddress.Text; studentGuardianRecord.AddedByID = Convert.ToInt64(this.Tag); studentGuardianRecord.AddedDateTime = System.DateTime.Now; studentGuardianRecord.LastUpdateByID = Convert.ToInt64(this.Tag); studentGuardianRecord.LastUpdateDateTime = System.DateTime.Now; studentGuardianRecord.Remarks = txtGuardianRemarks.Text; StudentGuardianRecordController.InsertUpdateStudentGuardianRecord(studentGuardianRecord); }
/////////////////////////////////////////////////////////////////////////////////////////// //Private Methods/////////////////////////////////////////////////////////////////////////// //DB to Model// private void GenerateModelList() { StudentGuardianRecordList.Clear(); foreach (DataRow drStudentGuardianRecord in dsStudentGuardianRecord.Tables[0].Rows) { StudentGuardianRecord objStudentGuardianRecord = new StudentGuardianRecord(); objStudentGuardianRecord.GuardianID = Convert.ToInt64(drStudentGuardianRecord["GuardianID"]); objStudentGuardianRecord.StudentID = Convert.ToInt64(drStudentGuardianRecord["StudentID"]); objStudentGuardianRecord.GuardianName = Convert.ToString(drStudentGuardianRecord["GuardianName"]); objStudentGuardianRecord.GuardianCNIC = Convert.ToString(drStudentGuardianRecord["GuardianCNIC"]); objStudentGuardianRecord.GuadianEmail = Convert.ToString(drStudentGuardianRecord["GuadianEmail"]); objStudentGuardianRecord.GuardianContact = Convert.ToString(drStudentGuardianRecord["GuardianContact"]); objStudentGuardianRecord.GuardianPic = Convert.ToString(drStudentGuardianRecord["GuardianPic"]); objStudentGuardianRecord.GuardianAddress = Convert.ToString(drStudentGuardianRecord["GuardianAddress"]); objStudentGuardianRecord.AddedByID = Convert.ToInt64(drStudentGuardianRecord["AddedByID"]); objStudentGuardianRecord.AddedDateTime = Convert.ToDateTime(drStudentGuardianRecord["AddedDateTime"]); objStudentGuardianRecord.LastUpdateDateTime = Convert.ToDateTime(drStudentGuardianRecord["LastUpdateDateTime"]); objStudentGuardianRecord.LastUpdateByID = Convert.ToInt64(drStudentGuardianRecord["LastUpdateByID"]); objStudentGuardianRecord.Remarks = Convert.ToString(drStudentGuardianRecord["Remarks"]); StudentGuardianRecordList.Add(objStudentGuardianRecord); } }
public static Int64 InsertUpdateStudentGuardianRecord(StudentGuardianRecord objIUStudentGuardianRecord) { Int64 new_id = objIUStudentGuardianRecord.InsertUpdateStudentGuardianRecord(); return(new_id); }