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