} //end function
public CollageAdmin CollageAdminSelectByID(int intUserId)
{
try
{
string sp_name = "CollageAdminSelectByID";
comCollageAdmin.Parameters.AddWithValue("UserId", intUserId);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsCollageAdmin.Tables[0].Rows.Count == 1)
{
DataRow drCollageAdmin = dsCollageAdmin.Tables[0].Rows[0];
CollageAdmin objCollageAdmin = new CollageAdmin();
objCollageAdmin.UserId = Convert.ToInt64(drCollageAdmin["UserId"]);
objCollageAdmin.UserName = Convert.ToString(drCollageAdmin["UserName"]);
objCollageAdmin.UserPassword = Convert.ToString(drCollageAdmin["UserPassword"]);
objCollageAdmin.UserEmail = Convert.ToString(drCollageAdmin["UserEmail"]);
objCollageAdmin.UserRole = Convert.ToString(drCollageAdmin["UserRole"]);
objCollageAdmin.UserContectNo = Convert.ToString(drCollageAdmin["UserContectNo"]);
objCollageAdmin.UserCNIC = Convert.ToString(drCollageAdmin["UserCNIC"]);
objCollageAdmin.AddedById = Convert.ToInt32(drCollageAdmin["AddedById"]);
objCollageAdmin.AddedByDateTime = Convert.ToDateTime(drCollageAdmin["AddedByDateTime"]);
objCollageAdmin.UserIsEnabled = Convert.ToBoolean(drCollageAdmin["UserIsEnabled"]);
objCollageAdmin.LastEnableDateTime = Convert.ToDateTime(drCollageAdmin["LastEnableDateTime"]);
objCollageAdmin.Remarks = Convert.ToString(drCollageAdmin["Remarks"]);
objCollageAdmin.UserPic = Convert.ToString(drCollageAdmin["UserPic"]);
return(objCollageAdmin);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
private void btnUserSave_Click(object sender, EventArgs e)
{
Image admin_pic = picUser.Image;
admin_pic.Save("images//admin//" + txtUserCNIC.Text + ".jpg");
if (IsFormValidate())
{
CollageAdmin objAdmin = new CollageAdmin();
objAdmin.UserId = Convert.ToInt32(txtUserName.Tag);
objAdmin.UserEmail = txtUserEmail.Text;
objAdmin.UserName = txtUserName.Text;
objAdmin.UserPassword = txtUserPassword.Text;
objAdmin.UserRole = cmbUserRole.Text;
objAdmin.UserContectNo = txtUserContactNo.Text;
objAdmin.UserCNIC = txtUserCNIC.Text;
objAdmin.AddedById = Convert.ToInt32(this.Tag);
objAdmin.AddedByDateTime = DateTime.Now;
objAdmin.UserIsEnabled = true;
objAdmin.LastEnableDateTime = DateTime.Now;
objAdmin.Remarks = txtUserRemarks.Text;
objAdmin.UserPic = "images//admin//" + txtUserCNIC.Text + ".jpg";
long UserId = objAdmin.InsertUpdateCollageAdmin();
if (UserId > 0)
{
UserDataGridView.DataSource = CollageAdminController.CollageAdminSelectAll();
SuccessMessage.SHowDialog("Record Entered Successfully");
txtUserName.Focus();
}
else
{
ErrorMessage.SHowDialog("Error in Entry");
txtUserName.Focus();
}
}
}
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
CollageAdminList.Clear();
foreach (DataRow drCollageAdmin in dsCollageAdmin.Tables[0].Rows)
{
CollageAdmin objCollageAdmin = new CollageAdmin();
objCollageAdmin.UserId = Convert.ToInt64(drCollageAdmin["UserId"]);
objCollageAdmin.UserName = Convert.ToString(drCollageAdmin["UserName"]);
objCollageAdmin.UserPassword = Convert.ToString(drCollageAdmin["UserPassword"]);
objCollageAdmin.UserEmail = Convert.ToString(drCollageAdmin["UserEmail"]);
objCollageAdmin.UserRole = Convert.ToString(drCollageAdmin["UserRole"]);
objCollageAdmin.UserContectNo = Convert.ToString(drCollageAdmin["UserContectNo"]);
objCollageAdmin.UserCNIC = Convert.ToString(drCollageAdmin["UserCNIC"]);
objCollageAdmin.AddedById = Convert.ToInt32(drCollageAdmin["AddedById"]);
objCollageAdmin.AddedByDateTime = Convert.ToDateTime(drCollageAdmin["AddedByDateTime"]);
objCollageAdmin.UserIsEnabled = Convert.ToBoolean(drCollageAdmin["UserIsEnabled"]);
objCollageAdmin.LastEnableDateTime = Convert.ToDateTime(drCollageAdmin["LastEnableDateTime"]);
objCollageAdmin.Remarks = Convert.ToString(drCollageAdmin["Remarks"]);
objCollageAdmin.UserPic = Convert.ToString(drCollageAdmin["UserPic"]);
CollageAdminList.Add(objCollageAdmin);
}
}
public static Int64 InsertUpdateCollageAdmin(CollageAdmin objIUCollageAdmin)
{
Int64 new_id = objIUCollageAdmin.InsertUpdateCollageAdmin();
return(new_id);
}
