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