public DataSet FTrainingmaster(Trainingmaster obj)
{
DataSet ds = null;
try
{
#region Parameters
string[,] str = new string[4, 2];
str[0, 0] = "@Action";
str[0, 1] = obj.Action;
str[1, 0] = "@Tid";
str[1, 1] = obj.T_Id.ToString();
str[2, 0] = "@Name";
if (obj.Name == null)
{
str[2, 1] = "";
}
else
{
str[2, 1] = obj.Name;
}
str[3, 0] = "@Active";
str[3, 1] = obj.Active.ToString();
#endregion
Database db = new Database();
ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_Training_Masters]", str);
return ds;
}
catch (Exception)
{
throw;
}
}
public DataSet OnlineCourseMasters(OnlineCourseMaster obj)
{
DataSet ds = null;
try
{
#region Parameters
string[,] str = new string[7, 2];
str[0, 0] = "@Action";
str[0, 1] = obj.Action;
str[1, 0] = "@id";
str[1, 1] = obj.Id.ToString();
str[2, 0] = "@Name";
if (obj.Name == null)
{
str[2, 1] = "";
}
else
{
str[2, 1] = obj.Name;
}
str[3, 0] = "@Details";
if (obj.Details == null)
{
str[3, 1] = "";
}
else
{
str[3, 1] = obj.Details;
}
str[4, 0] = "@C_Price";
if (obj.C_Price == null)
{
str[4, 1] = "";
}
else
{
str[4, 1] = obj.C_Price;
}
str[5, 0] = "@Active";
str[5, 1] = obj.Active.ToString();
str[6, 0] = "@slugName";
if (obj.Slug_Name == null)
{
str[6, 1] = "";
}
else
{
str[6, 1] = obj.Slug_Name;
}
#endregion
Database db = new Database();
ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_Onlinecourse_Masters]", str);
return ds;
}
catch (Exception)
{
throw;
}
}
public DataSet coursemaster(Coursemaster obj)
{
DataSet ds =null;
try
{
#region Parameters
string[,] str = new string[10, 2];
str[0, 0] = "@Action";
str[0, 1] = obj.Action;
str[1, 0] = "@C_Id";
str[1, 1] = obj.C_Id.ToString();
str[2, 0] = "@Trainingid";
str[2, 1] = obj.Trainingid.ToString();
str[3, 0] = "@Name";
if (obj.Name == null)
{
str[3, 1] = "";
}
else
{
str[3, 1] = obj.Name;
}
str[4, 0] = "@Date";
if (obj.Date == null)
{
str[4, 1] = "";
}
else
{
str[4, 1] = obj.Date;
}
str[5, 0] = "@Location";
if (obj.Location == null)
{
str[5, 1] = "";
}
else
{
str[5, 1] = obj.Location;
}
str[6, 0] = "@Duration";
str[6, 1] = obj.Duration.ToString();
str[7, 0] = "@Price";
str[7, 1] = obj.Price.ToString();
str[8, 0] = "@Active";
str[8, 1] = obj.Active.ToString();
str[9, 0] = "@SlugName";
if (obj.SlugName == null)
{
str[9, 1] = "";
}
else
{
str[9, 1] = obj.SlugName;
}
#endregion
Database db = new Database();
ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_Course_Masters]", str);
return ds;
}
catch (Exception)
{
throw;
}
}
public DataSet custmaster(Customerdata obj)
{
DataSet ds = null;
try
{
#region Parameters
string[,] str = new string[19, 2];
str[0, 0] = "@Action";
str[0, 1] = obj.Action;
str[1, 0] = "@C_Id";
str[1, 1] = obj.C_Id.ToString();
str[2, 0] = "@Cus_id";
if (obj.Cus_id == null)
{
str[2, 1] = "";
}
else
{
str[2, 1] = obj.Cus_id;
}
str[3, 0] = "@Title";
if (obj.Title == null)
{
str[3, 1] = "";
}
else
{
str[3, 1] = obj.Title;
}
str[4, 0] = "@Fname";
if (obj.Fname == null)
{
str[4, 1] = "";
}
else
{
str[4, 1] = obj.Fname;
}
str[5, 0] = "@Lname";
if (obj.Lname == null)
{
str[5, 1] = "";
}
else
{
str[5, 1] = obj.Lname;
}
str[6, 0] = "@cmpname";
if (obj.cmpname == null)
{
str[6, 1] = "";
}
else
{
str[6, 1] = obj.cmpname;
}
str[7, 0] = "@add1";
if (obj.add1 == null)
{
str[7, 1] = "";
}
else
{
str[7, 1] = obj.add1;
}
str[8, 0] = "@add2";
if (obj.add2 == null)
{
str[8, 1] = "";
}
else
{
str[8, 1] = obj.add2;
}
str[9, 0] = "@city";
if (obj.city == null)
{
str[9, 1] = "";
}
else
{
str[9, 1] = obj.city;
}
str[10, 0] = "@postcode";
if (obj.postcode == null)
{
str[10, 1] = "";
}
else
{
str[10, 1] = obj.postcode;
}
str[11, 0] = "@country";
if (obj.country == null)
{
str[11, 1] = "";
}
else
{
str[11, 1] = obj.country;
}
str[12, 0] = "@tele";
if (obj.tele == null)
{
str[12, 1] = "";
}
else
{
str[12, 1] = obj.tele;
}
str[13, 0] = "@mobile";
if (obj.mobile == null)
{
str[13, 1] = "";
}
else
{
str[13, 1] = obj.mobile;
}
str[14, 0] = "@mail";
if (obj.mail == null)
{
str[14, 1] = "";
}
else
{
str[14, 1] = obj.mail;
}
str[15, 0] = "@Transactionnumber";
if (obj.Transactionnumber == null)
{
str[15, 1] = "";
}
else
{
str[15, 1] = obj.Transactionnumber;
}
str[16, 0] = "@TotalAmount";
if (obj.TotalAmount == null)
{
str[16, 1] = "";
}
else
{
str[16, 1] = obj.TotalAmount;
}
str[17, 0] = "@Date";
if (obj.Tdate == null)
{
str[17, 1] = "";
}
else
{
str[17, 1] = obj.Tdate;
}
str[18, 0] = "@paymentst";
if (obj.paymentst == null)
{
str[18, 1] = "";
}
else
{
str[18, 1] = obj.paymentst;
}
#endregion
Database db = new Database();
ds = db.StoreprocedureExecuteDsReturned("[SP_HSRS_customer_det]", str);
return ds;
}
catch (Exception)
{
throw;
}
}
