public static ComplaintXEscalationLevel GetDetails(int id)
{
ComplaintXEscalationLevel info = null;
info = BaseDataAccess.GetRecords <ComplaintXEscalationLevel>(String.Format("select * from ComplaintXEscalationLevel where Id='{0}'", id));
if (info != null)
{
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
}
return(info);
}
/// <summary>
/// This Function is used to Delete previously added ComplaintXEscalationLevel from database and is performed by SuperAdmin Only.
/// </summary>
public static bool Delete(ComplaintXEscalationLevel info)
{
return(ComplaintXEscalationLevelDA.Delete(info));
}
/// <summary>
/// This Function is used to Update previously added ComplaintXEscalationLevel in database and is performed by SuperAdmin Only.
/// </summary>
public static bool Update(ComplaintXEscalationLevel info)
{
return(ComplaintXEscalationLevelDA.Update(info));
}
/// <summary>
/// This Function is used to add new ComplaintXEscalationLevel to database and is performed by SuperAdmin Only.
/// </summary>
public static bool Add(ComplaintXEscalationLevel info)
{
return(ComplaintXEscalationLevelDA.Add(info));
}
public static bool Delete(ComplaintXEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from ComplaintXEscalationLevel where Id='{0}'", info.Id)));
}
public static bool Update(ComplaintXEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("Update ComplaintXEscalationLevel set ComplaintId='{0}',EscalationLevelNumber='{1}', EscalationTime='{2}', EscalationReason='{3}' where Id='{4}'", info.ComplaintId, info.EscalationLevelNumber, info.EscalationTime, info.EscalationReason, info.Id)));
}
public static bool Add(ComplaintXEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into ComplaintXEscalationLevel(ComplaintId, EscalationLevelNumber, EscalationTime, EscalationReason) values ('{0}','{1}','{2}','{3}')", info.ComplaintId, info.EscalationLevelNumber, info.EscalationTime, info.EscalationReason)));
}
