public Mem_ProfessionalInfo GetMem_ProfessionalInfoFromReader(IDataReader reader)
{
try
{
Mem_ProfessionalInfo mem_ProfessionalInfo = new Mem_ProfessionalInfo
(
(int)reader["Mem_ProfessionalInfoID"],
reader["FromDate"].ToString(),
reader["ToDate"].ToString(),
reader["Designation"].ToString(),
(int)reader["Comn_OfficeID"],
reader["Details"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdatedBy"],
(DateTime)reader["UpdatedDate"],
(int)reader["Comn_RowStatusID"]
);
return(mem_ProfessionalInfo);
}
catch (Exception ex)
{
return(null);
}
}
public static Mem_ProfessionalInfo GetMem_ProfessionalInfoByID(int id)
{
Mem_ProfessionalInfo mem_ProfessionalInfo = new Mem_ProfessionalInfo();
SqlMem_ProfessionalInfoProvider sqlMem_ProfessionalInfoProvider = new SqlMem_ProfessionalInfoProvider();
mem_ProfessionalInfo = sqlMem_ProfessionalInfoProvider.GetMem_ProfessionalInfoByID(id);
return(mem_ProfessionalInfo);
}
public bool UpdateMem_ProfessionalInfo(Mem_ProfessionalInfo mem_ProfessionalInfo)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateMem_ProfessionalInfo", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Mem_ProfessionalInfoID", SqlDbType.Int).Value = mem_ProfessionalInfo.Mem_ProfessionalInfoID;
cmd.Parameters.Add("@FromDate", SqlDbType.NVarChar).Value = mem_ProfessionalInfo.FromDate;
cmd.Parameters.Add("@ToDate", SqlDbType.NVarChar).Value = mem_ProfessionalInfo.ToDate;
cmd.Parameters.Add("@Designation", SqlDbType.NVarChar).Value = mem_ProfessionalInfo.Designation;
cmd.Parameters.Add("@Comn_OfficeID", SqlDbType.Int).Value = mem_ProfessionalInfo.Comn_OfficeID;
cmd.Parameters.Add("@Details", SqlDbType.NText).Value = mem_ProfessionalInfo.Details;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = mem_ProfessionalInfo.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = mem_ProfessionalInfo.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = mem_ProfessionalInfo.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = mem_ProfessionalInfo.UpdatedDate;
cmd.Parameters.Add("@Comn_RowStatusID", SqlDbType.Int).Value = mem_ProfessionalInfo.Comn_RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static bool UpdateMem_ProfessionalInfo(Mem_ProfessionalInfo mem_ProfessionalInfo)
{
SqlMem_ProfessionalInfoProvider sqlMem_ProfessionalInfoProvider = new SqlMem_ProfessionalInfoProvider();
return(sqlMem_ProfessionalInfoProvider.UpdateMem_ProfessionalInfo(mem_ProfessionalInfo));
}
public static int InsertMem_ProfessionalInfo(Mem_ProfessionalInfo mem_ProfessionalInfo)
{
SqlMem_ProfessionalInfoProvider sqlMem_ProfessionalInfoProvider = new SqlMem_ProfessionalInfoProvider();
return(sqlMem_ProfessionalInfoProvider.InsertMem_ProfessionalInfo(mem_ProfessionalInfo));
}
