public static int Save(Entity.Member Member) { using (DataManager oDm = new DataManager()) { oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.Input, Member.MemberId); oDm.Add("@pMemberName", SqlDbType.VarChar, 50, ParameterDirection.Input, Member.MemberName); oDm.Add("@pFormNo", SqlDbType.VarChar, 20, ParameterDirection.Input, Member.FormNo); oDm.Add("@pFirmName", SqlDbType.VarChar, 50, ParameterDirection.Input, Member.FirmName); oDm.Add("@pAddress", SqlDbType.VarChar, 250, ParameterDirection.Input, Member.Address); oDm.Add("@pBlockName", SqlDbType.VarChar, 250, ParameterDirection.Input, Member.BlockName); oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, Member.DistrictId); oDm.Add("@pPin", SqlDbType.VarChar, 6, ParameterDirection.Input, Member.Pin); oDm.Add("@pMobileNo", SqlDbType.VarChar, 10, ParameterDirection.Input, Member.MobileNo); oDm.Add("@pLandLine", SqlDbType.VarChar, 20, ParameterDirection.Input, Member.LandLine); oDm.Add("@pStartDate", SqlDbType.DateTime, ParameterDirection.Input, Member.StartDate); oDm.Add("@pEndDate", SqlDbType.DateTime, ParameterDirection.Input, Member.EndDate); oDm.Add("@pIsLifeMembership", SqlDbType.Bit, ParameterDirection.Input, Member.IsLifeMembership); oDm.Add("@pLifeMembershipAmt", SqlDbType.Decimal, ParameterDirection.Input, Member.LifeMembershipAmt); oDm.Add("@pIsYearlySMSSubscriber", SqlDbType.Bit, ParameterDirection.Input, Member.IsYearlySMSSubscriber); oDm.Add("@pSMSSubscriberAmt", SqlDbType.Decimal, ParameterDirection.Input, Member.SMSSubscriberAmt); oDm.Add("@pSubscriptionId", SqlDbType.Int, ParameterDirection.Input, Member.SubscriptionId); oDm.Add("@pIsPortalMember", SqlDbType.Bit, ParameterDirection.Input, Member.IsPortalMember); oDm.Add("@pPortalMemberAmt", SqlDbType.Decimal, ParameterDirection.Input, Member.PortalMemberAmt); oDm.Add("@pIsMobileAppActivated", SqlDbType.Bit, ParameterDirection.Input, Member.IsMobileAppActivated); oDm.Add("@pDeviceId", SqlDbType.VarChar, 200, ParameterDirection.Input, Member.DeviceId); oDm.Add("@pPassword", SqlDbType.VarChar, 20, ParameterDirection.Input, Member.Password); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_Merchant_Save")); } }
public static void Unlock() { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_SMSTrigger_Unlock"); } }
public static void Save(string CurrentProvider) { using (DataManager oDm = new DataManager()) { oDm.Add("@pCurrentProvider", SqlDbType.VarChar, 50, CurrentProvider); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_CurrentProvider_Save"); } }
public static void Delete(int DistrictId) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, DistrictId); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_District_Delete"); } }
public static void DeleteFromBlockWithState(int BlockId) { using (DataManager oDm = new DataManager()) { oDm.Add("@pBlockWithStateId", SqlDbType.Int, ParameterDirection.Input, BlockId); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_BlockWithState_Delete"); } }
public static void UpdateNotificationDate(int MemberId) { using (DataManager oDm = new DataManager()) { oDm.Add("@MemberId", SqlDbType.Int, MemberId); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_UpdateNotificationDate"); } }
public static void Save(Entity.District District) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, District.DistrictId); oDm.Add("@pDistrictName", SqlDbType.VarChar, 50, ParameterDirection.Input, District.DistrictName); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_District_Save"); } }
public static int Subscription_Delete(Int64 subscriptionId) { using (DataManager oDm = new DataManager()) { oDm.Add("@SubscriptionId", SqlDbType.BigInt, ParameterDirection.Input, subscriptionId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_Subscription_Delete")); } }
public static void Exchange_BlockWithState(int BlockId1, int BlockId2) { using (DataManager oDm = new DataManager()) { oDm.Add("@pBlockId1", SqlDbType.Int, ParameterDirection.Input, BlockId1); oDm.Add("@pBlockId2", SqlDbType.Int, ParameterDirection.Input, BlockId2); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_BlockWithState_Exchange"); } }
public static int Save(int SMSAPIId) { using (DataManager oDm = new DataManager()) { oDm.Add("@SMSAPIId", SqlDbType.Int, SMSAPIId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_SMSAPI_Save")); } }
public static void ChangePassword(Entity.EmployeeMaster Employee) { using (DataManager oDm = new DataManager()) { oDm.Add("@EmployeeId", SqlDbType.Int, ParameterDirection.Input, Employee.EmployeeId); oDm.Add("@Password", SqlDbType.VarChar, 50, Employee.Password); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("ChangePassword"); } }
public static void QuickUpdate(int MemberId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@pMemberId", SqlDbType.Int, ParameterDirection.Input, MemberId); oDm.ExecuteNonQuery("usp_Member_QuickActivate"); } }
public static int Delete(int SMSAPIId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@SMSAPIId", SqlDbType.Int, ParameterDirection.Input, SMSAPIId); return(oDm.ExecuteNonQuery("Usp_SMSAPI_Delete")); } }
public static void SaveBlockWithState(Entity.Block Block) { using (DataManager oDm = new DataManager()) { oDm.Add("@pBlockWithStateId", SqlDbType.Int, ParameterDirection.Input, Block.BlockId); oDm.Add("@pStateId", SqlDbType.Int, ParameterDirection.Input, Block.StateId); oDm.Add("@pBlockName", SqlDbType.VarChar, 50, ParameterDirection.Input, Block.BlockName); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_BlockWithState_Save"); } }
public static void SavePortal(string UserName, int MobNoCount, int CharCount, int TotalCredit) { using (DataManager oDm = new DataManager()) { oDm.Add("@pUserName", SqlDbType.VarChar, 50, UserName); oDm.Add("@pMobNoCount", SqlDbType.Int, MobNoCount); oDm.Add("@pCharCount", SqlDbType.Int, CharCount); oDm.Add("@pTotalCredit", SqlDbType.Int, TotalCredit); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_SMSTriggerPortal_Save"); } }
public static int Save(string circular) { int result; using (DataManager oDm = new DataManager()) { oDm.Add("@pCircularBody", SqlDbType.NVarChar, 10000, circular); oDm.CommandType = CommandType.StoredProcedure; result = oDm.ExecuteNonQuery("usp_Circular_Save"); } return(result); }
public static int EndDate_Update(int memberId, DateTime endDate) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@MemberId", SqlDbType.Int, ParameterDirection.Input, memberId); oDm.Add("@EndDate", SqlDbType.DateTime, ParameterDirection.Input, endDate); return(oDm.ExecuteNonQuery("usp_EndDate_Update")); } }
public static void UpSave(Entity.Block Block) { using (DataManager oDm = new DataManager()) { oDm.Add("@pBlockId", SqlDbType.Int, ParameterDirection.Input, Block.BlockId); oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, Block.DistrictId); oDm.Add("@pBlockName", SqlDbType.VarChar, 50, ParameterDirection.Input, Block.BlockName); oDm.Add("@pPotatoTypeId", SqlDbType.Int, ParameterDirection.Input, Block.PotatoTypeId); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_UpBlock_Save"); } }
public static void Update(Entity.SMSBalance sMSBalance) { using (DataManager oDm = new DataManager()) { oDm.Add("@pBalanceId", SqlDbType.Int, sMSBalance.BalanceId); oDm.Add("@pBalance", SqlDbType.Decimal, sMSBalance.Balance); oDm.Add("@pExpanceBalance", SqlDbType.Decimal, sMSBalance.ExpanceBalance); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("SMSBalance_Update"); } }
public static int Subscription_Save(Entity.Subscription subscription) { using (DataManager oDm = new DataManager()) { oDm.Add("@SubscriptionId", SqlDbType.BigInt, ParameterDirection.Input, subscription.SubscriptionId); oDm.Add("@MemberId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.MemberId); oDm.Add("@FinancialYearId_FK", SqlDbType.Int, ParameterDirection.Input, subscription.FinancialYearId); oDm.Add("@Amount", SqlDbType.Decimal, ParameterDirection.Input, subscription.Amount); oDm.Add("@EntryDate", SqlDbType.DateTime, ParameterDirection.Input, subscription.EntryDate); oDm.Add("@Narration", SqlDbType.VarChar, 500, ParameterDirection.Input, subscription.Narration); oDm.Add("@CreatedBy", SqlDbType.VarChar, 50, ParameterDirection.Input, subscription.CreatedBy); oDm.Add("@MRNo", SqlDbType.VarChar, 50, ParameterDirection.Input, subscription.MRNo); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_Subscription_Save")); } }
public static void Save(Entity.AgentMaster agentmaster) { using (DataManager oDm = new DataManager()) { oDm.Add("@pAgentId", SqlDbType.Int, ParameterDirection.InputOutput, agentmaster.AgentId); oDm.Add("@pName", SqlDbType.VarChar, 50, agentmaster.Name); oDm.Add("@pEmail", SqlDbType.VarChar, 100, agentmaster.Email); oDm.Add("@pContactNo", SqlDbType.VarChar, 50, agentmaster.ContactNo); oDm.Add("@pPassword", SqlDbType.VarChar, 50, agentmaster.Password); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("AgentMaster_Save"); agentmaster.AgentId = (int)oDm["@pAgentId"].Value; } }
public static void BulkMobNoInsert(DataTable dtMobNo) { using (DataManager oDm = new DataManager()) { string MobNoXML = string.Empty; if (dtMobNo != null && dtMobNo.Rows.Count > 0) { using (DataSet ds = new DataSet()) { ds.Tables.Add(dtMobNo); MobNoXML = ds.GetXml(); } } oDm.Add("@pMobNo", SqlDbType.Xml, MobNoXML); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_Member_BulkInsert"); } }
public static void SaveUnloading(DataTable dtRate) { using (DataManager oDm = new DataManager()) { string RateDetailsXML = string.Empty; if (dtRate != null && dtRate.Rows.Count > 0) { using (DataSet ds = new DataSet()) { ds.Tables.Add(dtRate); RateDetailsXML = ds.GetXml(); } } oDm.Add("@pRateDetails", SqlDbType.Xml, RateDetailsXML); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_PotatoUnloading_Save"); } }
public static int Save(Entity.EmployeeMaster employeemaster) { using (DataManager oDm = new DataManager()) { oDm.Add("@EmployeeId", SqlDbType.Int, employeemaster.EmployeeId); oDm.Add("@FName", SqlDbType.VarChar, 50, employeemaster.FName); oDm.Add("@LName", SqlDbType.VarChar, 50, employeemaster.LName); oDm.Add("@Email", SqlDbType.VarChar, 50, employeemaster.Email); oDm.Add("@ContactNo", SqlDbType.VarChar, 50, employeemaster.ContactNo); oDm.Add("@BranchId", SqlDbType.Int, employeemaster.BranchId); oDm.Add("@DesignationId", SqlDbType.Int, employeemaster.DesignationId); oDm.Add("@Status", SqlDbType.Bit, employeemaster.Status); oDm.Add("@Password", SqlDbType.VarChar, 20, employeemaster.Password); oDm.Add("@CreatedBy", SqlDbType.Int, employeemaster.CreatedBy); //oDm.Add("@Address", SqlDbType.VarChar, 200, employeemaster.Address); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("EmployeeMaster_Save")); } }
public static void Save(string Date, DataTable dtRate) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDate", SqlDbType.DateTime, Convert.ToDateTime(Date)); string RateDetailsXML = string.Empty; if (dtRate != null && dtRate.Rows.Count > 0) { using (DataSet ds = new DataSet()) { ds.Tables.Add(dtRate); RateDetailsXML = ds.GetXml(); } } oDm.Add("@pRateDetails", SqlDbType.Xml, RateDetailsXML); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("usp_AIndiaMarketRate_Save"); } }