public void UpdateAdministrators(string admin_id, string fullname, string username, string PASSWORD,
string address, string phonenumber, string email,
int sortdisplay, DateTime createdate, string createdby, DateTime modified_date, string modified_by, int status, string roll)
{
string[] parameter = new string[] { "@ADMIN_ID", "@FULL_NAME", "@USERNAME", "@PASSWORD", "@ADDRESS", "@PHONE_NUMBER",
"@EMAIL", "@SORT_DISPLAY ", "@CREATED_DATE", "@CREATED_BY", "@MODIFIED_DATE", "@MODIFIED_BY", "@STATUS", "@ROLL" };
object[] objVal = new object[] { admin_id, fullname, username, PASSWORD, address, phonenumber, email, sortdisplay, createdate, createdby, modified_date, modified_by, status, roll };
cnts.ExcuteStored("tblAdministratorsUpdate", parameter, objVal);
}
public void Insert(string roleid, string functionid)
{
string[] arrParam = { "@ROLEID", "@FUNCTIONID" };
string[] arrValue = { roleid, functionid };
objConnect.ExcuteStored("tblRoleFunction_Insert", arrParam, arrValue);
}
public void Delete(int ID)
{
string[] parameter = new string[] { "@ID" };
object[] obj = new object[] { ID };
cnts.ExcuteStored("tblTestimonialDelete", parameter, obj);
}
public void Insert(string NAME, string IMAGE, string DESCRIPTION, DateTime CREATED_DATE, int STATUS)
{
string[] arrParam = { "@NAME", "@IMAGE", "@DESCRIPTION", "@CREATED_DATE", "@STATUS" };
object[] arrValue = { NAME, IMAGE, DESCRIPTION, CREATED_DATE, STATUS };
cnts.ExcuteStored("tblTeacher_Insert", arrParam, arrValue);
}
public void Insert(string SENDER, string RECIEVER, int EMAIL_ID, DateTime DATE_SENT, string CONTENT, int TYPE)
{
string[] para = { "@SENDER", "@RECIEVER", "@EMAIL_ID", "@DATE_SENT", "@CONTENT", "@TYPE" };
object[] obj = { SENDER, RECIEVER, EMAIL_ID, DATE_SENT, CONTENT, TYPE };
cnts.ExcuteStored("tblHistorySent_Insert", para, obj);
}
public void tblEmailTemplateUpdate(int EMAILID, string DESCRIPTION, string CONTENT, DateTime CREATEDDATE)
{
string[] parameter = new string[] { "@EMAILID", "@DESCRIPTION", "@CONTENT", "@CREATEDDATE" };
object[] obj = new object[] { EMAILID, DESCRIPTION, CONTENT, CREATEDDATE };
cnts.ExcuteStored("tblEmailTemplateUpdate", parameter, obj);
}
public void tblNewsDelete(int NEWSID)
{
string[] parameter = new string[] { "@ID" };
object[] obj = new object[] { NEWSID };
cnts.ExcuteStored("tblNewsDelete", parameter, obj);
}