public int InsertPlanTypeMaster(PLTaxi ObjPL)
{
try
{
SqlParameter[] _param =
{
new SqlParameter("@PLANTYPE", ObjPL.PlanType),
new SqlParameter("@PLAN_PRICE", ObjPL.Plan_Price),
};
_INS = objSQL.ExecuteProcedure("Usp_PLANTYPEMASTER_Insert", _param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
public int InsertBankMaster(PLTaxi ObjPL)
{
try
{
SqlParameter[] _param =
{
new SqlParameter("@BANKNAME", ObjPL.BankName),
new SqlParameter("@BRANCH", ObjPL.BranchName),
};
_INS = objSQL.ExecuteProcedure("Sp_BANKMASTER_INSERT", _param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
public int InsertHitList(PLTaxi ObjPL)
{
try
{
SqlParameter[] _param =
{
new SqlParameter("@IPADDR", ObjPL.IPAddr),
new SqlParameter("@HITDATE", ObjPL.HitDate),
new SqlParameter("@HITTIME", ObjPL.HitTime),
};
_INS = objSQL.ExecuteProcedure("USP_HITLIST_INSERT", _param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
public int InsertCutomerQuote(PLTaxi ObjPL)
{
try
{
SqlParameter[] _param =
{
new SqlParameter("@CUSTOMERNAME", ObjPL.CustomerName),
new SqlParameter("@MOBILENO", ObjPL.MobileNO),
new SqlParameter("@EMAILID", ObjPL.EmailId),
new SqlParameter("@CITY", ObjPL.City),
new SqlParameter("@PLANTYPEID", ObjPL.PlanID),
new SqlParameter("@STATUS", ObjPL.Status),
};
_INS = objSQL.ExecuteProcedure("USP_CUSTOMER_QUOTE_INSERT", _param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
public int InsertLoanMaster(PLTaxi ObjPL)
{
try
{
SqlParameter[] _param =
{
new SqlParameter("@BID", ObjPL.BID),
new SqlParameter("@LOANDT", ObjPL.LoanDt),
new SqlParameter("@AccountNo", ObjPL.AccountNo),
new SqlParameter("@DUEDT", ObjPL.DueDt),
new SqlParameter("@LAONAMT", ObjPL.LoanAmt),
new SqlParameter("@EMIAMT", ObjPL.EmiAmt),
new SqlParameter("@STATUS", ObjPL.Status),
};
_INS = objSQL.ExecuteProcedure("LOANMASTER_Insert_Sp", _param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
//public int InsertUserMaster(PLTaxi ObjPL)
//{
// try
// {
// SqlParameter[] _Param ={
// new SqlParameter("@UserName",ObjPL.strUserName),
// new SqlParameter("@Password",ObjPL.strPassword),
// new SqlParameter("@MobileNo",ObjPL.MobileNO),
// new SqlParameter("@Role",ObjPL.Role),
// new SqlParameter("@Created_Id",ObjPL.Enteredby),
// new SqlParameter("@Created_Date",ObjPL.CreatedDate),
// new SqlParameter("@Admin","Y"),
// new SqlParameter("@Status","V"),
// };
// _INS = objSQL.ExecuteProcedure("Usp_UserMaster_Insert", _Param);
// }
// catch (Exception Ex)
// {
// BLErrorLog.Write(Ex);
// }
// return _INS;
//}
public int InsertEndUserMaster(PLTaxi ObjPL)
{
try
{
SqlParameter[] _Param =
{
new SqlParameter("@UserName", ObjPL.strUserName),
new SqlParameter("@Password", ObjPL.strPassword),
new SqlParameter("@MobileNo", ObjPL.MobileNO),
new SqlParameter("@EmailId", ObjPL.EmailId),
new SqlParameter("@CreateDt", ObjPL.CreatedDate),
new SqlParameter("@Status", "Y"),
};
_INS = objSQL.ExecuteProcedure("Usp_ENDUSERMASTER_Insert", _Param);
}
catch (Exception Ex)
{
BLErrorLog.Write(Ex);
}
return(_INS);
}
