/// <summary>
/// Insert invoice bucket discount
/// </summary>
/// <param name="bucketInvoiceModel"></param>
/// <returns></returns>
public int InsertFinoInvoiceBucketDiscountDet(BucketInvoiceModel bucketInvoiceModel)
{
int result = 0;
string InvoiceIdStr = bucketInvoiceModel.InvoiceIDStr.TrimEnd(',');
DateTime PaymentDate = Convert.ToDateTime(bucketInvoiceModel.ValidToDate.TrimEnd(','));
try
{
IFormatProvider culture = new CultureInfo("en-US", true);
RepositoryService <BucketInvoiceModel> objBucketInvoiceModel = new RepositoryService <BucketInvoiceModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@BucketId", bucketInvoiceModel.BucketID == null ? 0 : bucketInvoiceModel.BucketID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@BucketName", bucketInvoiceModel.BucketName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@BucketStatus", bucketInvoiceModel.BucketStatus == null ? 4 : bucketInvoiceModel.BucketStatus, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@Discount", bucketInvoiceModel.DiscountPercentage, System.Data.SqlDbType.Decimal));
parameters.Add(SQLHelper.SqlInputParam("@UserId", bucketInvoiceModel.UserId, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@ValidToDate", PaymentDate, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@InvoiceIdString", InvoiceIdStr, System.Data.SqlDbType.VarChar));
result = objBucketInvoiceModel.ExecuteSqlCommand("Proc_InsertFinoInvoiceBucketDet @BucketId,@BucketName, @BucketStatus, @Discount, @UserId, @ValidToDate,@InvoiceIdString", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Register anchor company
/// </summary>
/// <param name="objCompany"></param>
/// <returns></returns>
public int UpdateProfile(Company objCompany)
{
int result = 0;
try
{
RepositoryService <Company> objComp = new RepositoryService <Company>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@CompanyID", objCompany.CompanyID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@Address", objCompany.Address, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Title", objCompany.Contact_Title, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Name", objCompany.Contact_Name, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Designation", objCompany.Contact_Designation, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Mobile", objCompany.Contact_mobile, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Comment", objCompany.Contact_Comments, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@UpdatedBy", objCompany.UpdatedBy, System.Data.SqlDbType.VarChar));//set UpdatedBy dynamically
result = objComp.ExecuteSqlCommand("proc_UpdateProfileAdminMaster @CompanyID,@Address,@Contact_Title,@Contact_Name,@Contact_Designation,@Contact_Mobile,@Contact_Comment,@UpdatedBy", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Insert update user record
/// </summary>
/// <param name="objUserPage"></param>
/// <returns></returns>
public int InsertUpdateUserRecord(UserModel objUserPage)
{
int result = 0;
try
{
RepositoryService <UserModel> objUserModel = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserID", objUserPage.UserID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@Name", objUserPage.Name, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Email", objUserPage.Email, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Mobile", objUserPage.Mobile, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Designation", objUserPage.Designation, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@RolesAccess", objUserPage.RoleAccessID, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@AccessViewID", objUserPage.AccessViewID, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@CreatedBy", objUserPage.CreatedBy, System.Data.SqlDbType.VarChar)); //set CreatedBy dynamically
parameters.Add(SQLHelper.SqlInputParam("@UpdatedBy", objUserPage.UpdatedBy, System.Data.SqlDbType.VarChar)); //set UpdatedBy dynamically
parameters.Add(SQLHelper.SqlInputParam("@Password", objUserPage.Password, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@CompanyID", objUserPage.CreatedBy, System.Data.SqlDbType.VarChar));
result = objUserModel.ExecuteSqlCommand("proc_AddUpdateUser @UserID, @Name, @Email, @Mobile, @Designation, @RolesAccess,@CreatedBy,@UpdatedBy,@AccessViewID,@Password,@CompanyID", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int DeleteHolidateReason(int ID)
{
int result = 0;
try
{
RepositoryService <InsertHoli_Reason> objComp = new RepositoryService <InsertHoli_Reason>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@ID", "" + ID + "", System.Data.SqlDbType.Int));
result = objComp.ExecuteSqlCommand("DeleteHolidate_Reason @ID", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Insert funding rate and date
/// </summary>
/// <param name="ObjAutoFunding"></param>
/// <returns></returns>
public int InsertFundingRateAndDate(AutoFunding ObjAutoFunding)
{
int result = 0;
try
{
RepositoryService <AutoFunding> objAutoFunding = new RepositoryService <AutoFunding>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@Rate", ObjAutoFunding.DiscuntRate, System.Data.SqlDbType.Decimal));
parameters.Add(SQLHelper.SqlInputParam("@Date", ObjAutoFunding.DiscuntVlidDate, System.Data.SqlDbType.DateTime));
result = objAutoFunding.ExecuteSqlCommand("proc_AddFundingRate @Rate,@Date", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// delete page by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteUserPage(int id)
{
int result = 0;
try
{
RepositoryService <UserModel> objUserModel = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserID", id, System.Data.SqlDbType.Int));
result = objUserModel.ExecuteSqlCommand("proc_deleteUser @UserID", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Update user
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public int UpdateUser(int?UserId, string role)
{
int result = 0;
try
{
RepositoryService <UserModel> objUserModel = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserID", UserId, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@role", role, System.Data.SqlDbType.VarChar));
result = objUserModel.ExecuteSqlCommand("proc_MarkAllReadNotifications @UserID,@role", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
//public void updateCompanyRate_Days(int? companyID, string percentageRate, int paymentDays)
//{
// throw new NotImplementedException();
//}
//public void updateCompanyRate_Days(string percentage, int paymentDays)
//{
// throw new NotImplementedException();
//}
public int InsertHolidateReason(int?UserID, DateTime?holidate, string reason)
{
int result = 0;
try
{
RepositoryService <InsertHoli_Reason> objComp = new RepositoryService <InsertHoli_Reason>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserID", "" + UserID + "", System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@Holidate", "" + holidate + "", System.Data.SqlDbType.DateTime));
parameters.Add(SQLHelper.SqlInputParam("@Reason", "" + reason + "", System.Data.SqlDbType.VarChar));
result = objComp.ExecuteSqlCommand("InsertHolidate_Reason @UserID,@Holidate,@Reason", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int DeleteCompanyById(string companyName, string panNumber)
{
int result = 0;
try
{
RepositoryService <Company> objComp = new RepositoryService <Company>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@CompanyName", "" + companyName + "", System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@PanNumber", "" + panNumber + "", System.Data.SqlDbType.VarChar));
result = objComp.ExecuteSqlCommand("proc_SoftdeleteCompnay @CompanyName,@PanNumber", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Update password
/// </summary>
/// <param name="Password"></param>
/// <param name="EmailID"></param>
/// <param name="Role"></param>
/// <returns></returns>
public int UpdatePassword(string Password, string EmailID, string Role)
{
int result = 0;
try
{
RepositoryService <UserModel> objUserModel = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@Role", Role, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Email", EmailID, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Password", Password, System.Data.SqlDbType.VarChar));
result = objUserModel.ExecuteSqlCommand("proc_UpdatePassword @Role, @Email, @Password", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Update new password
/// </summary>
/// <param name="objChangePassword"></param>
/// <returns></returns>
public int UpdateNewPassword(ChangePasswordModel objChangePassword)
{
int result = 0;
try
{
RepositoryService <UserModel> objUserModel = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@Role", objChangePassword.Role, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@UserId", objChangePassword.UserId, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@Password", objChangePassword.NewPassword, System.Data.SqlDbType.VarChar));
result = objUserModel.ExecuteSqlCommand("proc_ChangePassword @Role,@UserId,@Password", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Insert anchor company document record
/// </summary>
/// <param name="AnchorDocument"></param>
/// <param name="iAnchorCompanyID"></param>
/// <param name="iDocumentTypeID"></param>
/// <param name="LocalFolderFileName"></param>
/// <returns></returns>
public int AddUserNotificationMessage(int?UserID, string Description, int?RoleID, int?CreatedBy)
{
int result = 0;
try
{
RepositoryService <Notification> objNotificationModel = new RepositoryService <Notification>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserId", UserID, System.Data.SqlDbType.BigInt)); //set it dynamic
parameters.Add(SQLHelper.SqlInputParam("@RoleID", RoleID, System.Data.SqlDbType.BigInt)); //set it dynamic
parameters.Add(SQLHelper.SqlInputParam("@Description", Description, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@CreatedBy", CreatedBy, System.Data.SqlDbType.VarChar));
result = objNotificationModel.ExecuteSqlCommand("Proc_InsertNotificationForUser @UserId,@RoleID,@Description,@CreatedBy", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int AuditTrailLog(string ModuleName, string PageName, Int32?UserID, int CompanyID)
{
int result = 0;
try
{
RepositoryService <LogManagement> obj = new RepositoryService <LogManagement>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@ModuleName", ModuleName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@PageName", PageName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@UserID", UserID, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@CompanyID", CompanyID, System.Data.SqlDbType.VarChar));
result = obj.ExecuteSqlCommand("SP_SaveAuditTrailLog @ModuleName,@PageName,@UserID,@CompanyID", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Inser vendor's document details
/// </summary>
/// <param name="AnchorDocument"></param>
/// <param name="iVendorID"></param>
/// <param name="iDocumentTypeID"></param>
/// <param name="ToSaveFileName"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public int InsertDocumentDet(IFormFile AnchorDocument, int?iVendorID, int iDocumentTypeID, string ToSaveFileName, Int32?UserId)
{
int result = 0;
try
{
RepositoryService <DocumentModel> objDocumentModel = new RepositoryService <DocumentModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@VendorID", iVendorID, System.Data.SqlDbType.BigInt));//set it dynamic
parameters.Add(SQLHelper.SqlInputParam("@FileName", AnchorDocument.FileName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@DocumentTypeID", iDocumentTypeID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@UploadedBy", UserId, System.Data.SqlDbType.Int));//set it dynamic
parameters.Add(SQLHelper.SqlInputParam("@LocalFolderFileName", ToSaveFileName, System.Data.SqlDbType.VarChar));
result = objDocumentModel.ExecuteSqlCommand("Proc_InsertVendorDocDet @VendorID,@FileName, @DocumentTypeID, @UploadedBy,@LocalFolderFileName", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Register anchor company
/// </summary>
/// <param name="objCompany"></param>
/// <returns></returns>
public int UpdateSendGrid(EditSendGridDetailsModel objSendGridModel)
{
int result = 0;
try
{
RepositoryService <EditSendGridDetailsModel> objComp = new RepositoryService <EditSendGridDetailsModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@UserId", objSendGridModel.UserId, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Password", objSendGridModel.Password, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@HostName", objSendGridModel.HostName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@PortNO", objSendGridModel.PortNO, System.Data.SqlDbType.VarChar));
result = objComp.ExecuteSqlCommand("proc_AddUpdateSendGrid @UserId,@Password, @HostName, @PortNO", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Register anchor company
/// </summary>
/// <param name="objCompany"></param>
/// <returns></returns>
public int UpdateUserProfile(UserModel objUserPage)
{
int result = 0;
try
{
RepositoryService <UserModel> objComp = new RepositoryService <UserModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@CompanyID", objUserPage.CompanyID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@Name", objUserPage.Name, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Designation", objUserPage.Designation, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Mobile", objUserPage.Mobile, System.Data.SqlDbType.VarChar));
result = objComp.ExecuteSqlCommand("proc_UpdateProfileUserMaster @CompanyID,@Name,@Designation,@Mobile", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Update funding
/// </summary>
/// <param name="id"></param>
/// <param name="rate"></param>
/// <param name="date"></param>
/// <returns></returns>
public int Updatefunding(string id, string rate, string date)
{
int result = 0;
try
{
string AutoFudngId = id;
string DiscuntRate = rate;
string DiscuntVlidDate = date;
RepositoryService <AutoFunding> objAutoFunding = new RepositoryService <AutoFunding>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@AutoFudngId", AutoFudngId, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@DiscuntRate", DiscuntRate, System.Data.SqlDbType.Decimal));
parameters.Add(SQLHelper.SqlInputParam("@DiscuntVlidDate", DiscuntVlidDate, System.Data.SqlDbType.DateTime));
result = objAutoFunding.ExecuteSqlCommand("UPDATEFUNDING @AutoFudngId,@DiscuntRate,@DiscuntVlidDate", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int LogManagement(string ControllerName, string ActionName, string ErrorMessage, int ErrorLine, Int32?UserID)
{
int result = 0;
try
{
RepositoryService <LogManagement> obj = new RepositoryService <LogManagement>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@ControllerName", ControllerName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@ActionName", ActionName, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Message", ErrorMessage, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@ErrorLine", ErrorLine, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@UserID", UserID, System.Data.SqlDbType.VarChar));
result = obj.ExecuteSqlCommand("SP_SaveLogManagement @ControllerName,@ActionName,@Message,@ErrorLine,@UserID", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// save and update invoice approval record
/// </summary>
/// <param name="objUserPage"></param>
/// <returns></returns>
public int InsertUpdateApprovalRecord(InvoiceApprovalOrderModel objUserPage)
{
int result = 0;
try
{
RepositoryService <InvoiceApprovalOrderModel> objInvoiceApprovalOrderModel = new RepositoryService <InvoiceApprovalOrderModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@ApprovalID", objUserPage.ApprovalID, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@FromAmount", objUserPage.FromAmount, System.Data.SqlDbType.Decimal));
parameters.Add(SQLHelper.SqlInputParam("@ToAmount", objUserPage.ToAmount, System.Data.SqlDbType.Decimal));
parameters.Add(SQLHelper.SqlInputParam("@ApprovedBy", objUserPage.ApprovedBy, System.Data.SqlDbType.Int));
parameters.Add(SQLHelper.SqlInputParam("@Users", objUserPage.Users, System.Data.SqlDbType.VarChar));
result = objInvoiceApprovalOrderModel.ExecuteSqlCommand("proc_AddUpdateInvoiceApproved @ApprovalID,@FromAmount, @ToAmount, @ApprovedBy, @Users", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int SendNotification(BucketInvoiceModel bucketInvoiceModel, Int32?UserId, Int32?VendorId)
{
int result = 0;
string InvoiceIdStr = bucketInvoiceModel.InvoiceIDStr.TrimEnd(',');
try
{
RepositoryService <BucketInvoiceModel> objBucketInvoiceModel = new RepositoryService <BucketInvoiceModel>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@RoleID", 1, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@UserID", UserId, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@VendorID", VendorId, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@InvoiceIdString", InvoiceIdStr, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Discount", bucketInvoiceModel.DiscountPercentage, System.Data.SqlDbType.Decimal));
result = objBucketInvoiceModel.ExecuteSqlCommand("Proc_InsertAnchorNotify @RoleID,@UserID,@VendorID,@InvoiceIdString,@Discount", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// Register anchor company
/// </summary>
/// <param name="objCompany"></param>
/// <returns></returns>
public int InsertAnchorCompanyRegister(Company objCompany)
{
int result = 0;
try
{
RepositoryService <Company> objComp = new RepositoryService <Company>(_vContext);
ICollection <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SQLHelper.SqlInputParam("@CompanyID", objCompany.CompanyID, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@Company_Name", objCompany.Company_name, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Login_Id", objCompany.Login_id, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Password", SecurityHelperService.Encrypt(objCompany.Password), System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Address", objCompany.Address, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@InterestedAS", objCompany.InterestedAs, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@CompanyType", objCompany.CompanyType, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Pan_Number", objCompany.Pan_number, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Title", objCompany.Contact_Title, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Name", objCompany.Contact_Name, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Designation", objCompany.Contact_Designation, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Email", objCompany.Contact_email, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Mobile", objCompany.Contact_mobile, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_Comment", objCompany.Contact_Comments, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@Contact_CIN", objCompany.Contact_CIN, System.Data.SqlDbType.VarChar));
parameters.Add(SQLHelper.SqlInputParam("@CreatedBy", objCompany.CreatedBy, System.Data.SqlDbType.VarChar)); //set CreatedBy dynamically
parameters.Add(SQLHelper.SqlInputParam("@UpdatedBy", objCompany.UpdatedBy, System.Data.SqlDbType.VarChar)); //set UpdatedBy dynamically
parameters.Add(SQLHelper.SqlInputParam("@FactoryOrReverseFactory", objCompany.FactoryOrReverseFactory, System.Data.SqlDbType.BigInt));
parameters.Add(SQLHelper.SqlInputParam("@Status", objCompany.status, System.Data.SqlDbType.Int));
result = objComp.ExecuteSqlCommand("proc_AddUpdateCompany @CompanyID,@Company_Name, @Login_Id, @Password,@Address, @InterestedAS,@CompanyType,@Pan_Number,@Contact_CIN,@Contact_Title,@Contact_Name,@Contact_Designation,@Contact_Email,@Contact_Mobile,@Contact_Comment,@CreatedBy,@UpdatedBy,@FactoryOrReverseFactory,@Status", parameters.ToArray());
}
catch (Exception ex)
{
throw ex;
}
return(result);
}