/// <returns></returns>
private Int32 AddPettycash(Entities.Pettycash Petty)
{
var PettycashId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertPettycase))
{
database.AddInParameter(dbCommand, "@docno", DbType.String, Petty.DocNo);
database.AddInParameter(dbCommand, "@dates", DbType.Date, Petty.EntryDate);
database.AddInParameter(dbCommand, "@daterange", DbType.String, Petty.DateRange);
database.AddInParameter(dbCommand, "@accountheadid", DbType.Int32, Petty.AccountHeadId);
database.AddInParameter(dbCommand, "@nameofsupplier", DbType.String, Petty.Supplier);
database.AddInParameter(dbCommand, "@voucherno", DbType.String, Petty.VoucherNo);
database.AddInParameter(dbCommand, "@Amount", DbType.String, Petty.Amount);
database.AddInParameter(dbCommand, "@created_by", DbType.Int32, Petty.CreatedBy);
database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, Petty.CreatedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
PettycashId = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
PettycashId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(PettycashId);
}
/// <summary>
///
/// </summary>
/// <param name="employerId"></param>
/// <returns></returns>
public Entities.Pettycash GetPettycashDetailsById(Int32 employerId)
{
var Petty = new Entities.Pettycash();
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetEmployerDetailsById))
{
database.AddInParameter(dbCommand, "@employer_id", DbType.Int32, employerId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var _Petty = new Entities.Pettycash
{
// EmployerId = DRE.GetNullableInt32(reader, "employer_id", null),
// EmployerName = DRE.GetNullableString(reader, "employer_name", null),
// EmployerAddress = DRE.GetNullableString(reader, "employer_address", null),
// CountryId = DRE.GetNullableInt32(reader, "country_id", null),
// StateId = DRE.GetNullableInt32(reader, "state_id", null),
// CityId = DRE.GetNullableInt32(reader, "city_id", null),
// PinCode = DRE.GetNullableString(reader, "pin_code", null),
// Website = DRE.GetNullableString(reader, "website", null),
// GSTINNo = DRE.GetNullableString(reader, "gstin_no", null)
};
Petty = _Petty;
}
}
}
return(Petty);
}
/// <summary>
///
/// </summary>
/// <param name="employer"></param>
/// <returns></returns>
public bool DeletePettyCash(Entities.Pettycash Petty)
{
bool isDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.Deletepettycase))
{
database.AddInParameter(dbCommand, "@pettycase_id", DbType.Int32, Petty.PettycaseId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, Petty.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, Petty.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(isDeleted);
}
public string generateReportsss(Entities.Pettycash Petty)
{
var report = new BuidReport();
var reportEntity = new Entities.Report();
var reportName = string.Empty;
var folderName = string.Empty;
//var serverPath = HttpContext.Current.Server.MapPath("../POS/");
var parameters = new ArrayList();
parameters.Add(Petty.FromDate);
parameters.Add(Petty.ToDate);
folderName = "PettyCashReport";
reportName = "PettyCashReport.rpt";
var serverPath = HttpContext.Current.Server.MapPath("/HealthScreeningApp/");
reportEntity.DirectoryPath = serverPath + "ApplicationFiles/" + folderName + "/";
reportEntity.ReportPath = serverPath + "Reports/" + reportName;
reportEntity.Parameters = parameters;
reportEntity.FileStoragePath = reportEntity.DirectoryPath + Convert.ToString("PettyCashReport") + ".pdf";
return(report.GenerateReport(reportEntity, CrystalDecisions.Shared.ExportFormatType.PortableDocFormat));
}
/// <summary>
/// /
/// </summary>
/// <returns></returns>
public List <Entities.Pettycash> GetAllPettyCashDocno()
{
var Pettys = new List <Entities.Pettycash>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllPettycase))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var Petty = new Entities.Pettycash
{
PettycaseId = DRE.GetNullableInt32(reader, "pettycase_id", 0),
DocNo = DRE.GetNullableString(reader, "docno", null),
EntryDate = DRE.GetNullableString(reader, "Date", null),
DateRange = DRE.GetNullableString(reader, "daterange", null),
AccountHead = DRE.GetNullableString(reader, "account_head_name", null),
Supplier = DRE.GetNullableString(reader, "nameofsupplier", null),
VoucherNo = DRE.GetNullableString(reader, "voucherno", null),
Amount = DRE.GetNullableDecimal(reader, "Amount", 0),
guid = DRE.GetNullableGuid(reader, "row_guid", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
Pettys.Add(Petty);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Pettys);
}
public Int32 SavePettycash(Entities.Pettycash Petty)
{
var PettyCaseId = 0;
if (Petty == null || Petty.PettycaseId == 0)
{
PettyCaseId = AddPettycash(Petty);
}
else if (Petty.ModifiedBy != null || Petty.ModifiedBy > 0)
{
PettyCaseId = UpdatePettycash(Petty);
}
else if (Petty.DeletedBy != null || Petty.DeletedBy > 0)
{
var result = DeletePettyCash(Petty);
if (result == true)
{
PettyCaseId = 1;
}
}
return(PettyCaseId);
}
/// <summary>
///
/// </summary>
/// <param name="employer"></param>
/// <returns></returns>
public Int32 SavePettycash(Entities.Pettycash Petty)
{
return(_Petty.SavePettycash(Petty));
}
public String printPettyCashReport(Entities.Pettycash Petty)
{
return(_Petty.generateReportsss(Petty));
}
