} //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);
}
