public bool InsertPaypalTransactionData(string guid, string paymentid, long ApplicationID)
{
bool IsSuccessful;
SqlCommand cmd;
try
{
_sqlConnService.OpenConnection();
cmd = new SqlCommand("SP_SaveDeletePaypalTransaction", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Guid.NewGuid());
cmd.Parameters.AddWithValue("@GUID", guid);
cmd.Parameters.AddWithValue("@PAYMENTID", paymentid);
cmd.Parameters.AddWithValue("@APPID", ApplicationID);
cmd.Parameters.AddWithValue("@STATEMENT_TYPE", "INSERT");
cmd.ExecuteNonQuery();
IsSuccessful = true;
}
catch (Exception ex)
{
IsSuccessful = false;
}
finally
{
_sqlConnService.CloseConnection();
}
return(IsSuccessful);
}
public List <TranslationCertificateSettingsModel> GetTranslationCertificateSettingsList(BaseViewModel model)
{
SqlCommand cmd;
SqlDataReader Reader;
TranslationCertificateSettingsModel SettingsModel;
List <TranslationCertificateSettingsModel> SettingsList = new List <TranslationCertificateSettingsModel>();
_sqlConnService.OpenConnection();
try
{
cmd = new SqlCommand("SP_GetAllTranslationCertificateSettings", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
Reader = cmd.ExecuteReader();
while (Reader.Read() == true)
{
SettingsModel = new TranslationCertificateSettingsModel();
SettingsModel.ID = Convert.ToInt64(Reader["ID"].ToString());
SettingsModel.CertificateType = (CertificateType)Convert.ToInt32(Reader["CertificateType"].ToString());
SettingsModel.UnitPrice = Convert.ToInt64(Reader["UnitPrice"].ToString());
SettingsList.Add(SettingsModel);
}
}
catch (Exception ex)
{
IErrorLogService errorLog = new ErrorLogService();
string message = ex.InnerException != null ? ex.InnerException.InnerException.Message : ex.Message;
errorLog.SetErrorLog(model.CurrentUserID, "Transcription Estimation Input", message);
throw new Exception(message);
}
finally
{
_sqlConnService.CloseConnection();
}
return(SettingsList);
}
public List <StaffPaymentModel> GetStaffPaymentList(BaseViewModel model)
{
List <StaffPaymentModel> staffPaymentList = new List <StaffPaymentModel>();
try
{
StaffPaymentModel staffpayment;
_sqlConnService.OpenConnection();
SqlCommand command = new SqlCommand("SP_GetStaffPayment", _sqlConnService.CreateConnection());
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@CultureId", model.CurrentCulture);
command.Parameters.AddWithValue("@STAFFNO", DBNull.Value);
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
staffpayment = new StaffPaymentModel();
// staffpayment.Number = dr["Number"].ToString();
staffpayment.Name = dr["Name"].ToString();
// staffpayment.TradingCorporationID = Convert.ToInt32(dr["TradingCorporationID"].ToString());
// staffpayment.TradingCorporation = dr["TradingCorporation"].ToString();
staffpayment.DepositeType = dr["DepositeType"].ToString();
if (dr["AccountTypeID"] != DBNull.Value)
{
staffpayment.DepositeTypeId = Convert.ToInt64(dr["AccountTypeID"].ToString());
}
staffpayment.Bank = dr["Bank"].ToString();
staffpayment.BankId = dr["BankId"] != DBNull.Value? Guid.Parse(dr["BankId"].ToString()): Guid.Empty;
staffpayment.Branch = dr["Branch"].ToString();
staffpayment.BranchId = dr["BankBranchID"] != DBNull.Value? Guid.Parse(dr["BankBranchID"].ToString()):Guid.Empty;
staffpayment.AccountNumber = dr["AccountNumber"].ToString();
staffpayment.AccountHolder = dr["AccountHolder"].ToString();
// staffpayment.RemittableAmount = decimal.Parse(dr["RemittableAmount"].ToString());
// staffpayment.Carryover = decimal.Parse(dr["Carryover"].ToString());
// staffpayment.LastAdjustmentAmount = decimal.Parse(dr["LastAdjustmentAmount"].ToString());
// staffpayment.ScheduledRemittanceAmount = decimal.Parse(dr["ScheduledRemittanceAmount"].ToString());
// staffpayment.StaffBurdenFee = decimal.Parse(dr["StaffBurdenFee"].ToString());
// staffpayment.BcauseBurdenFee = decimal.Parse(dr["BcauseBurdenFee"].ToString());
// staffpayment.StaffTransferAmount = decimal.Parse(dr["StaffTransferAmount"].ToString());
// staffpayment.BcauseTransferAmount = decimal.Parse(dr["BcauseTransferAmount"].ToString());
// staffpayment.MoneyTransfer = decimal.Parse(dr["MoneyTransfer"].ToString());
// staffpayment.RemittanceDate = Convert.ToDateTime(dr["RemittanceDate"].ToString());
// staffpayment.RemittedAmount = decimal.Parse(dr["RemittedAmount"].ToString());
// staffpayment.AdjustmentAmount = decimal.Parse(dr["AdjustmentAmount"].ToString());
// staffpayment.Notes = dr["Notes"].ToString();
staffpayment.Email = dr["Email"].ToString();
staffPaymentList.Add(staffpayment);
}
_sqlConnService.CloseConnection();
}
catch (Exception ex) { }
return(staffPaymentList);
}
/*******************************************************************************************************************************
* *****************************************************************************************************************************
* *****************************************************************************************************************************
* *****************************************************************************************************************************/
public List <TransproLanguagePriceCategoryModel> DeleteTransproLanguagePriceCategory(TransproLanguagePriceCategoryModel PriceCategoryModel)
{
SqlCommand cmd;
try
{
_sqlConnService.OpenConnection();
cmd = new SqlCommand("SP_SaveDeleteTransproLanguagePriceDetails", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PriceCategoryID", PriceCategoryModel.ID);
cmd.Parameters.AddWithValue("@StatementType", "DeleteByPriceCategoryID");
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SP_SaveDeleteTransproLanguagePriceCategory", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", PriceCategoryModel.ID);
cmd.Parameters.AddWithValue("@StatementType", "Delete");
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
IErrorLogService errorLog = new ErrorLogService();
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
errorLog.SetErrorLog(PriceCategoryModel.CurrentUserID, "Transpro", message);
throw new Exception(message);
}
finally
{
_sqlConnService.CloseConnection();
}
TransproLanguagePriceCategoryQueryModel BaseModel = new TransproLanguagePriceCategoryQueryModel();
BaseModel.CurrentCulture = PriceCategoryModel.CurrentCulture;
BaseModel.CurrentUserID = PriceCategoryModel.CurrentUserID;
return(this.GetTransproLanguagePriceCategoryList(BaseModel));
}
public bool SaveEstimation(EstimationModel model)
{
SqlCommand cmd, cmd2, cmd3;
bool isSuccessful = false;
Guid EstimationID;
try
{
_sqlConnService.OpenConnection();
cmd = new SqlCommand("SP_SaveEstimation", _sqlConnService.CreateConnection());
cmd.CommandType = CommandType.StoredProcedure;
string EstimationNumber = GenerateEstimationNumber(model);
cmd.Parameters.AddWithValue("@InquiryDate", model.InquiryDate);
cmd.Parameters.AddWithValue("@ApplicationID", model.ApplicationId);
cmd.Parameters.AddWithValue("@EstimationRouteID", model.EstimateRouteID);
cmd.Parameters.AddWithValue("@OutwardSalesID", model.OutwardSalesID);
cmd.Parameters.AddWithValue("@LargeSalesID", model.LargeSalesID);
cmd.Parameters.AddWithValue("@SalesPersonID", model.SalesPersonID);
cmd.Parameters.AddWithValue("@AssistantID", model.AssistantID);
cmd.Parameters.AddWithValue("@CoordinatorID", model.CoordinatorID);
cmd.Parameters.AddWithValue("@ApprovalID", model.ApprovalID);
cmd.Parameters.AddWithValue("@ClientID", model.ClientID);
cmd.Parameters.AddWithValue("@TradingID", model.TradingID);
cmd.Parameters.AddWithValue("@TeamID", model.TeamID);
cmd.Parameters.AddWithValue("@IsCompanyPrivate", model.IsCompanyPrivate);
cmd.Parameters.AddWithValue("@ClientStatus", model.ClientStatus);
cmd.Parameters.AddWithValue("@SubSpecializedFieldID", model.SubSpecializedFieldID);
cmd.Parameters.AddWithValue("@ClientDepartmentID", model.ClientDepartmentID);
cmd.Parameters.AddWithValue("@BusinessCategoryID", model.BusinessCategoryID);
cmd.Parameters.AddWithValue("@ClientPersonInCharge", model.ClientPersonInCharge);
cmd.Parameters.AddWithValue("@ClientEmailCC", model.ClientEmailCC);
cmd.Parameters.AddWithValue("@ClientAddress_" + model.CurrentCulture, model.ClientAddress);
cmd.Parameters.AddWithValue("@ClientContactNo", model.ClientContactNo);
cmd.Parameters.AddWithValue("@ClientFax", model.ClientFax);
cmd.Parameters.AddWithValue("@BillingCompanyName_" + model.CurrentCulture, model.BillingCompanyName);
cmd.Parameters.AddWithValue("@BillingTo", model.BillingTo);
cmd.Parameters.AddWithValue("@BillingEmailCC", model.BillingEmailCC);
cmd.Parameters.AddWithValue("@BillingAddress_" + model.CurrentCulture, model.BillingAddress);
cmd.Parameters.AddWithValue("@BillingContactNo", model.BillingContactNo);
cmd.Parameters.AddWithValue("@BillingFax", model.BillingFax);
cmd.Parameters.AddWithValue("@IsPostingBill", model.IsPostingBill);
cmd.Parameters.AddWithValue("@PaymentTerms", model.PaymentTerms);
cmd.Parameters.AddWithValue("@DeliveryCompanyName_" + model.CurrentCulture, model.DeliveryCompanyName);
cmd.Parameters.AddWithValue("@DeliveryTo", model.DeliveryTo);
cmd.Parameters.AddWithValue("@DeliveryEmailCC", model.DeliveryEmailCC);
cmd.Parameters.AddWithValue("@DeliveryAddress_" + model.CurrentCulture, model.DeliveryAddress);
cmd.Parameters.AddWithValue("@DeliveryContactNo", model.DeliveryContactNo);
cmd.Parameters.AddWithValue("@DeliveryFax", model.DeliveryFax);
cmd.Parameters.AddWithValue("@DeliveryInstruction", model.DeliveryInstruction);
cmd.Parameters.AddWithValue("@RemarksCoordinatorType", model.RemarksCoordinatorType);
cmd.Parameters.AddWithValue("@CurrencyID", model.CurrencyID);
cmd.Parameters.AddWithValue("@IsProspect", model.IsProspect);
cmd.Parameters.AddWithValue("@IsUndisclosed", model.IsUndisclosed);
cmd.Parameters.AddWithValue("@EstimationType", model.EstimationType);
//cmd.Parameters.AddWithValue("@EstimationStatus", model.EstimationStatus);
cmd.Parameters.AddWithValue("@SpecializedFieldID", model.SpecializedFieldID);
cmd.Parameters.AddWithValue("@IsInternalPurpose", model.IsInternalPurpose);
cmd.Parameters.AddWithValue("@IsExternalPurpose", model.IsExternalPurpose);
cmd.Parameters.AddWithValue("@IsPrintPurpose", model.IsPrintPurpose);
cmd.Parameters.AddWithValue("@IsWebPurpose", model.IsWebPurpose);
cmd.Parameters.AddWithValue("@IsOtherPurpose", model.IsOtherPurpose);
cmd.Parameters.AddWithValue("@OtherPurposeText", model.OtherPurposeText);
cmd.Parameters.AddWithValue("@PriorityQuality", model.PriorityQuality);
cmd.Parameters.AddWithValue("@PriorityPrice", model.PriorityPrice);
cmd.Parameters.AddWithValue("@PriorityDelivery", model.PriorityDelivery);
cmd.Parameters.AddWithValue("@PriorityTender", model.PriorityTender);
cmd.Parameters.AddWithValue("@KnownByGoogle", model.KnownByGoogle);
cmd.Parameters.AddWithValue("@KnownByYahoo", model.KnownByYahoo);
cmd.Parameters.AddWithValue("@KnownByEmail", model.KnownByEmail);
cmd.Parameters.AddWithValue("@KnownByBing", model.KnownByBing);
cmd.Parameters.AddWithValue("@KnownByOthers", model.KnownByOthers);
cmd.Parameters.AddWithValue("@KnownOtherText", model.KnownOtherText);
cmd.Parameters.AddWithValue("@FinalDeliveryDate", model.FinalDeliveryDate);
cmd.Parameters.AddWithValue("@FirstDeliveryDate", model.FirstDeliveryDate);
cmd.Parameters.AddWithValue("@CoordinatorNotes_" + model.CurrentCulture, model.CoordinatorNotes);
cmd.Parameters.AddWithValue("@Remarks_" + model.CurrentCulture, model.Remarks);
cmd.Parameters.AddWithValue("@IsRemarksHideInPDF", model.IsRemarksHideInPDF);
cmd.Parameters.AddWithValue("@IsOrderReceived", model.IsOrderReceived);
cmd.Parameters.AddWithValue("@DiscountTotal", model.DiscountTotal);
cmd.Parameters.AddWithValue("@AverageUnitPrice", model.AverageUnitPrice);
cmd.Parameters.AddWithValue("@ActualUnitPrice", model.ActualUnitPrice);
cmd.Parameters.AddWithValue("@IsDeleted", model.IsDeleted);
cmd.Parameters.AddWithValue("@PurposeDetails", model.PurposeDetails);
cmd.Parameters.AddWithValue("@OrderTitle", model.OrderTitle);
cmd.Parameters.AddWithValue("@IssuedByTranslator", model.IssuedByTranslator);
cmd.Parameters.AddWithValue("@IssuedByCompany", model.IssuedByCompany);
cmd.Parameters.AddWithValue("@PriceCertification", model.PriceCertification);
cmd.Parameters.AddWithValue("@OtherItemName_" + model.CurrentCulture, model.OtherItemName);
cmd.Parameters.AddWithValue("@OtherItemUnitPrice", model.OtherItemUnitPrice);
cmd.Parameters.AddWithValue("@OtherItemNumber", model.OtherItemNumber);
cmd.Parameters.AddWithValue("@OtherAmount", model.OtherAmount);
cmd.Parameters.AddWithValue("@TaxEstimation", model.TaxEstimation);
cmd.Parameters.AddWithValue("@QuotationInclTax", model.QuotationInclTax);
cmd.Parameters.AddWithValue("@QuotationExclTax", model.QuotationExclTax);
cmd.Parameters.AddWithValue("@ConsumptionOnTax", model.ConsumptionOnTax);
cmd.Parameters.AddWithValue("@ExcludedTaxCost", model.ExcludedTaxCost);
cmd.Parameters.AddWithValue("@IsCampaign", model.IsCampaign);
cmd.Parameters.AddWithValue("@IsSpecialPrice", model.IsSpecialPrice);
cmd.Parameters.AddWithValue("@IsSpecialDeal", model.IsSpecialDeal);
cmd.Parameters.AddWithValue("@IsPromotion", model.IsPromotion);
cmd.Parameters.AddWithValue("@IsSpecialPayment", model.IsSpecialPayment);
cmd.Parameters.AddWithValue("@IsPastComplaint", model.IsPastComplaint);
cmd.Parameters.AddWithValue("@IsExpertise", model.IsExpertise);
cmd.Parameters.AddWithValue("@IsOnGoingTask", model.IsOnGoingTask);
cmd.Parameters.AddWithValue("@IsOverSeas", model.IsOverseas);
cmd.Parameters.AddWithValue("@IsJapan", model.IsJapan);
cmd.Parameters.AddWithValue("@CountryID", model.CountryID);
cmd.Parameters.AddWithValue("@KnownByIntroduction", model.KnownByIntroduction);
cmd.Parameters.AddWithValue("@KnownIntroductionText", model.KnownIntroductionText);
cmd.Parameters.AddWithValue("@AttachedMaterialFileName", model.AttachedMaterialFileName);
cmd.Parameters.AddWithValue("@AttachedMaterialDownloadURL", model.AttachedMaterialDownloadURL);
cmd.Parameters.AddWithValue("@IsContentAll", model.IsContentAll);
cmd.Parameters.AddWithValue("@IsPerformance", model.IsPerformance);
cmd.Parameters.AddWithValue("@IsAccuracy", model.IsAccuracy);
cmd.Parameters.AddWithValue("@IsLocal", model.IsLocal);
cmd.Parameters.AddWithValue("@QuotationNotes_" + model.CurrentCulture, model.QuotationNotes);
cmd.Parameters.AddWithValue("@StartDate", model.StartDate);
cmd.Parameters.AddWithValue("@EndDate", model.EndDate);
cmd.Parameters.AddWithValue("@UnitID", model.UnitID);
cmd.Parameters.AddWithValue("@CreatedBy", model.CurrentUserID);
if (model.ID == Guid.Empty)
{
EstimationID = Guid.NewGuid();
cmd.Parameters.AddWithValue("@ID", EstimationID);
cmd.Parameters.AddWithValue("@EstimationNo", EstimationNumber);
cmd.Parameters.AddWithValue("@RegistrationDate", DateTime.Now);
cmd.Parameters.AddWithValue("@StatementType", "Insert");
}
else
{
EstimationID = model.ID;
cmd.Parameters.AddWithValue("@ID", EstimationID);
cmd.Parameters.AddWithValue("@EstimationNo", model.EstimationNo);
cmd.Parameters.AddWithValue("@RegistrationDate", model.RegistrationDate);
cmd.Parameters.AddWithValue("@StatementType", "Update");
}
cmd.ExecuteNonQuery(); // Run stored procedure to store Estimation on database
foreach (EstimationDetailsModel DetailsModel in model.EstimationItems)
{
Guid EstimationDetailsID;
DetailsModel.StartTime = DetailsModel.NewStartTime;
DetailsModel.FinishTime = DetailsModel.NewFinishTime;
cmd2 = new SqlCommand("SP_SaveEstimationDetails", _sqlConnService.CreateConnection());
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@EstimationID", EstimationID);
cmd2.Parameters.AddWithValue("@SourceLanguageID", DetailsModel.SourceLanguageID);
cmd2.Parameters.AddWithValue("@TargetLanguageID", DetailsModel.TargetLanguageID);
cmd2.Parameters.AddWithValue("@ServiceType", DetailsModel.ServiceType);
cmd2.Parameters.AddWithValue("@UnitPrice1", DetailsModel.UnitPrice1);
cmd2.Parameters.AddWithValue("@UnitPrice2", DetailsModel.UnitPrice2);
cmd2.Parameters.AddWithValue("@UnitPrice3", DetailsModel.UnitPrice3);
cmd2.Parameters.AddWithValue("@UnitPrice4", DetailsModel.UnitPrice4);
cmd2.Parameters.AddWithValue("@UnitPrice5", DetailsModel.UnitPrice5);
cmd2.Parameters.AddWithValue("@Discount1", DetailsModel.Discount1);
cmd2.Parameters.AddWithValue("@Discount2", DetailsModel.Discount2);
cmd2.Parameters.AddWithValue("@Discount3", DetailsModel.Discount3);
cmd2.Parameters.AddWithValue("@Discount4", DetailsModel.Discount4);
cmd2.Parameters.AddWithValue("@Discount5", DetailsModel.Discount5);
cmd2.Parameters.AddWithValue("@PageCount1", DetailsModel.PageCount1);
cmd2.Parameters.AddWithValue("@PageCount2", DetailsModel.PageCount2);
cmd2.Parameters.AddWithValue("@PageCount3", DetailsModel.PageCount3);
cmd2.Parameters.AddWithValue("@PageCount4", DetailsModel.PageCount4);
cmd2.Parameters.AddWithValue("@PageCount5", DetailsModel.PageCount5);
cmd2.Parameters.AddWithValue("@BasicTime", DetailsModel.BasicTime);
cmd2.Parameters.AddWithValue("@AdditionalBasicAmount", DetailsModel.AdditionalBasicAmount);
cmd2.Parameters.AddWithValue("@AdditionalTime", DetailsModel.AdditionalTime);
cmd2.Parameters.AddWithValue("@ExtensionTime", DetailsModel.ExtensionTime);
cmd2.Parameters.AddWithValue("@ExtraTime", DetailsModel.ExtraTime);
cmd2.Parameters.AddWithValue("@LateNightTime", DetailsModel.LateNightTime);
cmd2.Parameters.AddWithValue("@TransferTime", DetailsModel.TransferTime);
cmd2.Parameters.AddWithValue("@BasicAmount", DetailsModel.BasicAmount);
cmd2.Parameters.AddWithValue("@ExtensionAmount", DetailsModel.ExtensionAmount);
cmd2.Parameters.AddWithValue("@ExtraAmount", DetailsModel.ExtraAmount);
cmd2.Parameters.AddWithValue("@LateAtNightAmount", DetailsModel.LateAtNightAmount);
cmd2.Parameters.AddWithValue("@TransferAmount", DetailsModel.TransferAmount);
cmd2.Parameters.AddWithValue("@NumberOfDays", DetailsModel.NumberOfDays);
cmd2.Parameters.AddWithValue("@NumberOfPeople", DetailsModel.NumberOfPeople);
cmd2.Parameters.AddWithValue("@OtherAmount", DetailsModel.OtherAmount);
cmd2.Parameters.AddWithValue("@CertificateAmount", DetailsModel.CertificateAmount);
cmd2.Parameters.AddWithValue("@ExcludeTax", DetailsModel.ExcludeTax);
cmd2.Parameters.AddWithValue("@LengthMinute", DetailsModel.LengthMinute);
cmd2.Parameters.AddWithValue("@WithTranslation", DetailsModel.WithTranslation);
cmd2.Parameters.AddWithValue("@StartDate", DetailsModel.StartDate);
cmd2.Parameters.AddWithValue("@CompletionDate", DetailsModel.CompletionDate);
cmd2.Parameters.AddWithValue("@StartTime", DetailsModel.StartTime);
cmd2.Parameters.AddWithValue("@FinishTime", DetailsModel.FinishTime);
cmd2.Parameters.AddWithValue("@Contents", DetailsModel.Contents);
cmd2.Parameters.AddWithValue("@IsOverseas", DetailsModel.IsOverseas);
cmd2.Parameters.AddWithValue("@Total", DetailsModel.Total);
cmd2.Parameters.AddWithValue("@TotalAfterDiscount", DetailsModel.TotalAfterDiscount);
cmd2.Parameters.AddWithValue("@DiscountedPrice", DetailsModel.DiscountedPrice);
cmd2.Parameters.AddWithValue("@DiscountRate", DetailsModel.DiscountRate);
cmd2.Parameters.AddWithValue("@UnitPriceSubTotal", DetailsModel.UnitPriceSubTotal);
cmd2.Parameters.AddWithValue("@PaymentRate", DetailsModel.PaymentRate);
cmd2.Parameters.AddWithValue("@ExpectedPayment", DetailsModel.ExpectedPayment);
if (DetailsModel.IsMarkedForDelete == true)
{
EstimationDetailsID = Guid.Empty;
cmd2.Parameters.AddWithValue("@ID", DetailsModel.ID);
cmd2.Parameters.AddWithValue("@StatementType", "Delete");
}
else if (DetailsModel.ID == Guid.Empty)
{
EstimationDetailsID = Guid.NewGuid();
cmd2.Parameters.AddWithValue("@ID", EstimationDetailsID);
cmd2.Parameters.AddWithValue("@StatementType", "Insert");
}
else
{
EstimationDetailsID = DetailsModel.ID;
cmd2.Parameters.AddWithValue("@ID", EstimationDetailsID);
cmd2.Parameters.AddWithValue("@StatementType", "Update");
}
cmd2.ExecuteNonQuery(); // Run stored procedure to store EstimationDetails on database
if (DetailsModel.IsMarkedForDelete == true)
{
goto LOOP_END;
}
isSuccessful = true;
LOOP_END :;
}
foreach (OrderStaffAllowanceModel collection in model.CollectionFee)
{
if (collection.SubTotal > 0 || collection.IsMarkedForDelete == true)
{
Guid AllowanceID;
cmd3 = new SqlCommand("SP_SaveOrderStaffAllowance", _sqlConnService.CreateConnection());
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.AddWithValue("@ItemName", collection.ItemName);
cmd3.Parameters.AddWithValue("@UnitPrice", collection.UnitPrice);
cmd3.Parameters.AddWithValue("@NoOfPersons", collection.NoOfPersons);
cmd3.Parameters.AddWithValue("@NoOfDays", collection.NoOfDays);
cmd3.Parameters.AddWithValue("@SubTotal", collection.SubTotal);
cmd3.Parameters.AddWithValue("@AllowanceType", collection.AllowanceType);
cmd3.Parameters.AddWithValue("@IsCompleteSet", collection.IsCompleteSet);
cmd3.Parameters.AddWithValue("@IsExclTax", collection.IsExclTax);
if (collection.IsMarkedForDelete == true)
{
//Delete the record
cmd3.Parameters.AddWithValue("@ID", collection.ID);
cmd3.Parameters.AddWithValue("@StatementType", "Delete");
}
else if (collection.EstimationID == Guid.Empty)
{
// Insert the record
collection.EstimationID = EstimationID;
AllowanceID = Guid.NewGuid();
collection.ID = AllowanceID;
cmd3.Parameters.AddWithValue("@ID", collection.ID);
cmd3.Parameters.AddWithValue("@EstimationID", collection.EstimationID);
cmd3.Parameters.AddWithValue("@StatementType", "Insert");
}
else
{
// Update the record
cmd3.Parameters.AddWithValue("@ID", collection.ID);
cmd3.Parameters.AddWithValue("@EstimationID", collection.EstimationID);
cmd3.Parameters.AddWithValue("@StatementType", "Update");
}
cmd3.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
isSuccessful = false;
IErrorLogService errorLog = new ErrorLogService();
string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
errorLog.SetErrorLog(model.CurrentUserID, "Estimation", message);
throw new Exception(message);
}
finally
{
_sqlConnService.CloseConnection();
}
return(isSuccessful);
}
public List <UserInfoModel> GetSearchUserList(BaseViewModel model, string con)
{
List <UserInfoModel> userInfoList = new List <UserInfoModel>();
UserInfoModel userInfoModel;
try
{
string branch = con.Split(',')[0];
string type = con.Split(',')[1];
string eid = con.Split(',')[2];
string resign = con.Split(',')[3];
string role = con.Split(',')[4];
string author = con.Split(',')[5];
string ename = con.Split(',')[6];
_sqlConnService.OpenConnection();
SqlCommand command = new SqlCommand("SP_GetSearchAllUser", _sqlConnService.CreateConnection());
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@CultureId", model.CurrentCulture);
if (model.ID == Guid.Empty)
{
command.Parameters.AddWithValue("@ID", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@ID", model.ID);
}
command.Parameters.AddWithValue("@EmployeeId", DBNull.Value);
command.Parameters.AddWithValue("@UserTypeId", DBNull.Value);
if (branch == "")
{
command.Parameters.AddWithValue("@branch", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@branch", branch);
}
if (type == "")
{
command.Parameters.AddWithValue("@type", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@type", type);
}
if (eid == "")
{
command.Parameters.AddWithValue("@eid", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@eid", eid);
}
if (resign == "")
{
command.Parameters.AddWithValue("@resign", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@resign", resign);
}
if (role == "")
{
command.Parameters.AddWithValue("@role", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@role", role);
}
if (author == "")
{
command.Parameters.AddWithValue("@author", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@author", author);
}
if (ename == "")
{
command.Parameters.AddWithValue("@ename", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@ename", ename);
}
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
userInfoModel = new UserInfoModel();
userInfoModel.Id = Convert.ToInt32(reader["ID"].ToString());
userInfoModel.FirstName = reader["FirstName"].ToString();
userInfoModel.LastName = reader["LastName"].ToString();
userInfoModel.EmployeeID = Guid.Parse(reader["EmployeeID"].ToString());
userInfoModel.MobileNo = reader["MobileNo"].ToString();
userInfoModel.Email = reader["Email"].ToString();
userInfoModel.Address = reader["Address"].ToString();
userInfoModel.UserTypeId = Convert.ToInt32(reader["UserTypeId"].ToString());
userInfoModel.RoleId = Convert.ToInt32(reader["RoleId"].ToString());
userInfoModel.Username = reader["Username"].ToString();
userInfoModel.Password = reader["Password"].ToString();
userInfoModel.IsActive = Convert.ToBoolean(reader["Active"].ToString());
userInfoModel.CreatedDate = Convert.ToDateTime(reader["CreatedDate"].ToString());
userInfoModel.CreatedBy = Convert.ToInt32(reader["CreatedBy"].ToString());
userInfoModel.UpdatedDate = Convert.ToDateTime(reader["UpdatedDate"].ToString());
userInfoModel.UpdatedBy = Convert.ToInt32(reader["UpdatedBy"].ToString());
userInfoList.Add(userInfoModel);
}
_sqlConnService.CloseConnection();
}
catch (Exception ex)
{
string message = LogException(ex, model.CurrentUserID);
throw new Exception(message);
}
return(userInfoList);
}
