public tblUserMasterViewModel()
{
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
tblusermaster = new tblUserMasterInfo();
tblusermasters = new List <tblUserMasterInfo>();
}
private tblUserMasterInfo Get_tblUserMaster_Values(DataRow dr)
{
tblUserMasterInfo tblusermaster = new tblUserMasterInfo();
tblusermaster.Id = Convert.ToInt32(dr["Id"]);
tblusermaster.UserName = Convert.ToString(dr["UserName"]);
tblusermaster.Password = Convert.ToString(dr["Password"]);
tblusermaster.Linkedwith = Convert.ToString(dr["Linkedwith"]);
tblusermaster.Active = Convert.ToBoolean(dr["Active"]);
tblusermaster.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
tblusermaster.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
tblusermaster.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
tblusermaster.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
return(tblusermaster);
}
private List <SqlParameter> Set_Values_In_tblUserMaster(tblUserMasterInfo tblusermaster)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Id", tblusermaster.Id));
sqlParams.Add(new SqlParameter("@UserName", tblusermaster.UserName));
sqlParams.Add(new SqlParameter("@Password", tblusermaster.Password));
sqlParams.Add(new SqlParameter("@Linkedwith", tblusermaster.Linkedwith));
sqlParams.Add(new SqlParameter("@Active", tblusermaster.Active));
sqlParams.Add(new SqlParameter("@CreatedBy", tblusermaster.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", tblusermaster.CreatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", tblusermaster.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", tblusermaster.UpdatedOn));
return(sqlParams);
}
public void Update_tblUserMaster(tblUserMasterInfo tblusermaster)
{
_tblusermasterRepo.Update_tblUserMaster(tblusermaster);
}
public void Insert_tblUserMaster(tblUserMasterInfo tblusermaster)
{
_tblusermasterRepo.Insert_tblUserMaster(tblusermaster);
}
public void Update_tblUserMaster(tblUserMasterInfo tblusermaster)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_tblUserMaster(tblusermaster), StoredProcedures.Update_tblUserMaster.ToString(), CommandType.StoredProcedure);
}