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