static async Task SeedChalan(IGenericRepository <Chalan> repo)
{
var defaultSub = await repo.FilterAsync(p => p.Name == "N/A");
if (!defaultSub.Any())
{
var sub = new Chalan {
Name = "N/A"
};
await repo.CreateAsync(sub);
}
}
private Chalan MapChalan(DbDataReader dr)
{
Chalan chalan = new Chalan();
chalan.ChalanId = NullHandler.GetString(dr["ChalanId"]);
chalan.ChalanNo = NullHandler.GetString(dr["ChalanNo"]);
chalan.ItemId = NullHandler.GetString(dr["ItemId"]);
chalan.ItemName = NullHandler.GetString(dr["ItemName"]);
chalan.CountPerBox = NullHandler.GetInt32(dr["CountPerBox"]);
chalan.EntryCount = NullHandler.GetInt32(dr["EntryCount"]);
chalan.ChalanDate = NullHandler.GetDateTime(dr["ChalanDate"]);
chalan.CalculateBoxesFromTotalChalan();
return(chalan);
}
private void btnReport_Click_1(object sender, EventArgs e)
{
Chalan sal = new Chalan();
ReportDocument cryRpt = new ReportDocument();
cryRpt = sal;
DataTable formula = Connstring.SqlDataTable(@"SELECT No, CONVERT(CHAR(10), Date, 103) AS Date, FromBranch, ToBranch, Remark, ProductCode, ProductName, Quantity
FROM vinv.Chalan WHERE (No = '" + Txt_cash_memo_no.Text + "')");
cryRpt.SetDataSource(formula);
Rpt_Viewer.RptDoc = cryRpt;
Rpt_Viewer.ShowDialog();
Cursor.Current = Cursors.Default;
}
public SavingState SaveChalan(Chalan chalan)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(chalan.ChalanNo))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new chalan
if (!IsItemChalanExist(chalan.ChalanNo, chalan.ItemId, chalan.ChalanDate))
{
thisCommand.CommandText = "INSERT INTO IM_Chalan_Activity (ChalanId, ChalanNo, ItemId, EntryCount, ChalanDate) VALUES(@ChalanId, @ChalanNo, @ItemId, @EntryCount, @ChalanDate)";
CreateParameter.AddParam(thisCommand, "@ChalanId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
thisCommand.CommandText = "UPDATE IM_Chalan_Activity SET EntryCount = @EntryCount WHERE ItemId = @ItemId AND ChalanNo = @ChalanNo AND ChalanDate = @ChalanDate";
}
CreateParameter.AddParam(thisCommand, "@ChalanNo", chalan.ChalanNo, DbType.String);
CreateParameter.AddParam(thisCommand, "@ItemId", chalan.ItemId, DbType.String);
CreateParameter.AddParam(thisCommand, "@EntryCount", chalan.EntryCount, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ChalanDate", chalan.ChalanDate.Date, DbType.Date);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
